package org.jeecg.modules.sanitation2.entity;

import java.io.Serializable;
import java.io.UnsupportedEncodingException;
import java.util.Date;
import java.math.BigDecimal;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.springframework.format.annotation.DateTimeFormat;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.jeecg.common.aspect.annotation.Dict;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

/**
 * @Description: 统计查询
 * @Author: jeecg-boot
 * @Date:   2021-05-19
 * @Version: V1.0
 */
@Data
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = false)
@ApiModel(value="statisticalQuery对象", description="统计查询")
public class StatisticalQuery implements Serializable {
    private static final long serialVersionUID = 1L;

	/**主键*/
//	@TableId(type = IdType.ASSIGN_ID)
    @ApiModelProperty(value = "主键")
	@TableField(exist = false)
    private String id;
	/**校区*/
	@Excel(name = "校区", width = 15, dictTable = "lwgy_base_apartment", dicText = "name", dicCode = "id")
	@Dict(dictTable = "lwgy_base_apartment", dicText = "name", dicCode = "id")
	@TableField(exist = false)
    @ApiModelProperty(value = "校区")
    private String campusId;
	/**楼宇*/
	@Excel(name = "楼宇", width = 15, dictTable = "lwgy_base_apartment", dicText = "name", dicCode = "id")
	@Dict(dictTable = "lwgy_base_apartment", dicText = "name", dicCode = "id")
    @ApiModelProperty(value = "楼宇")
	@TableField(exist = false)
    private String buildingId;
	/**单元*/
	@Excel(name = "单元", width = 15, dictTable = "lwgy_base_apartment", dicText = "name", dicCode = "id")
	@Dict(dictTable = "lwgy_base_apartment", dicText = "name", dicCode = "id")
    @ApiModelProperty(value = "单元")
	@TableField(exist = false)
    private String unitId;
	/**楼层*/
	@Excel(name = "楼层", width = 15, dictTable = "lwgy_base_apartment", dicText = "name", dicCode = "id")
	@Dict(dictTable = "lwgy_base_apartment", dicText = "name", dicCode = "id")
    @ApiModelProperty(value = "楼层")
	@TableField(exist = false)
    private String layerId;
	/**房间*/
	@Excel(name = "房间", width = 15)
	@Dict(dictTable = "lwgy_base_apartment", dicText = "name", dicCode = "id")
    @ApiModelProperty(value = "房间")
	@TableField(exist = false)
    private String roomId;
	/**打分时间*/
	@Excel(name = "打分时间", width = 15)
    @ApiModelProperty(value = "打分时间")
	@TableField(exist = false)
    private String scoringTime;

	@Excel(name = "打分批次", width = 15)
	@Dict(dictTable = "lwgy_setting_sanitation", dicText = "batch_name", dicCode = "id")
	@TableField(exist = false)
	private String scaleBatches;
	/**学院*/
	@Excel(name = "学院", width = 15)
	@Dict(dictTable = "lwgy_base_school", dicText = "name", dicCode = "id")
	@TableField(exist = false)
    @ApiModelProperty(value = "学院")
    private String faculty;
	/**专业*/
	@Excel(name = "专业", width = 15)
	@TableField(exist = false)
	@Dict(dictTable = "lwgy_base_school", dicText = "name", dicCode = "id")
	@ApiModelProperty(value = "专业")
    private String major;
	/**班级*/
	@Excel(name = "班级", width = 15)
	@TableField(exist = false)
	@Dict(dictTable = "lwgy_base_school", dicText = "name", dicCode = "id")
	@ApiModelProperty(value = "班级")
    private String classes;
	/**学生*/
	@Excel(name = "学生", width = 15)
	@TableField(exist = false)
    @ApiModelProperty(value = "学生")
    private String studentId;
	/**辅导员*/
	@Excel(name = "辅导员", width = 15)
	@TableField(exist = false)
    @ApiModelProperty(value = "辅导员")
    private String instructor;
	/**平均成绩*/
	@Excel(name = "平均成绩", width = 15)
    @ApiModelProperty(value = "平均成绩")
	@TableField(exist = false)
    private Double avgScore = 100.0;
	/**等级*/
	@Excel(name = "等级", width = 15)
	@TableField(exist = false)
    @ApiModelProperty(value = "等级")
    private String grade = "A";
}
